Data Discovery Analyst (Financial Service Domains)
Core Responsibilities
Data Exploration & Validation:
• Analyze and assess data sources for analytical readiness and business alignment.
• Acquire and compile structured and unstructured data, verifying its quality, accuracy, and reasonableness.
• Perform analyses of historical data to surface trends and insights using advanced analytical methods.
• Validate analytical techniques employed by other analysts.
Cross Functional Collaboration:
• Partner with cross-functional teams to translate business questions into actionable data solutions.
• Engage with internal partners to understand business strategy, questions, and goals.
• Participate in cross-divisional data projects and resolve operational challenges.
Prototyping & Data Storytelling:
• Build visualizations and proof-of-concepts to demonstrate data value and insights.
• Prepare and deliver visualizations and internal presentations that translate analytic insights into tangible, actionable solutions for business partners to implement.
• Develop, own, and manage recurring analytic or reporting processes.
Data Quality & Governance:
• Identify and resolve data inconsistencies, gaps, and ensure compliance with governance standards.
User Enablement:
• Empower non-technical users to leverage data products effectively through documentation and training.
• Foster a culture of continuous learning and innovation in analytics tools and methods.
• Proactively expand knowledge of business and analytics, share best practices, and document them.
• Serve as a subject matter expert for the team and the analytic organization.
Required Skills & Tools:
Advanced SQL expertise including:
• Multi-table joins (inner, outer, cross, self-joins)
• Subqueries and common table expressions (CTEs)
• Window functions (RANK, ROW_NUMBER, PARTITION BY)
• Aggregations and grouping logic
• Ability to optimize, troubleshoot, and validate SQL logic on large-scale datasets
• Strong experience querying and analyzing data through platforms such as Athena, Dremio, or similar distributed compute engines.
• Data Visualization:
• Ability to source and model data in Tableau or Power BI from scratch
• Build highly functional and intuitive dashboards that reflect UX best practices and visual storytelling principles
• Ability to design layout, structure, hierarchy, and visual selection based on business intent
Python:
• Ability to read and understand Python scripts used for data preparation
• Ability to write Python is a plus, especially for deeper analysis or working closely with engineering teams
Collaboration Tools:
• JIRA, Confluence, Mural/Figma for documentation, refinement, and sprint collaboration
• Collibra for data governance, documentation, and stewardship processes
Soft Skills:
• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management capabilities
• Strong ability to translate technical data concepts to business-friendly narratives
Special Factors
Sponsorship
Vanguard is not offering visa sponsorship for this position.
About Vanguard
At Vanguard, we don't just have a mission-we're on a mission.
To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best.
How We Work
Vanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience.
